/* *****************************************
   Nueva vista

	vstklote

   Ale
 ******************************************/


CREATE OR REPLACE VIEW public.vstklote AS 
 SELECT artm.idart,
    artm.nrolote,
    artm.fechalote,
    sum(artm.signo * artm.cant) AS cant
   FROM artm
  GROUP BY artm.idart, artm.nrolote, artm.fechalote;

ALTER TABLE public.vstklote OWNER TO abacouser;



-- =================================
SELECT aaversion('430.02','430.01');
-- =================================